SQL Practice Ground

Practice

Select difficulty and a question

Practice Mode

Timed Challenge Timed challenge toggle Enable

Timer (minutes)

Learning Path

Follow a structured curriculum to master SQL

Open

Recommended modules

Pick a topic and learn with examples, then come back to practice.

SQL Basics (Beginner)

SELECT, FROM, WHERE, ORDER BY

Learn

JOIN Operations (Beginner)

INNER, LEFT, RIGHT, FULL, CROSS

Learn

Aggregate Functions (Intermediate)

COUNT, SUM, AVG, GROUP BY, HAVING

Learn

Subqueries (Intermediate)

Nested queries, IN, EXISTS

Learn

Set Operators (Intermediate)

UNION, UNION ALL, INTERSECT, EXCEPT

Learn

Conditional Expressions (Intermediate)

CASE, COALESCE, IFNULL

Learn

Common Table Expressions (Advanced)

WITH, recursive CTEs

Learn

Window Functions (Advanced)

ROW_NUMBER, RANK, LEAD, LAG

Learn

Use these relationships in JOINs: orders.customer_id = customers.id, order_items.order_id = orders.id, order_items.product_id = products.id.

SQL Editor 00:00

SELECT * FROM customers;

Results

Run a query to see results
Demo runner supports basic SELECT on customers only (UI replica focus). [1] [2]

customers

Column	Type
id	INTEGER
first_name	VARCHAR (50)
last_name	VARCHAR (50)
email	VARCHAR (100)
registration_date	DATE

customers schema above is taken from the default view snippet that is publicly indexed. [1] [2]

orders

Column	Type
id	INTEGER
customer_id	INTEGER
order_date	DATE
status	VARCHAR (20)

order_items

Column	Type
order_id	INTEGER
product_id	INTEGER
quantity	INTEGER
price_per_unit	DECIMAL (10, 2)

products

Column	Type
id	INTEGER
name	VARCHAR (100)
category	VARCHAR (50)
price	DECIMAL (10, 2)

employees

Column	Type
id	INTEGER (PRIMARY KEY)
name	VARCHAR (100) NOT NULL
title	VARCHAR (100) NOT NULL
hire_date	DATE
salary	DECIMAL (10, 2) NOT NULL
department	VARCHAR (50) NOT NULL

customers (sample)

id	first_name	last_name	email	registration_date

Sample rows shown here are synthetic demo data (UI replica focus). [1]

orders (sample)

id	customer_id	order_date	status

order_items (sample)

order_id	product_id	quantity	price_per_unit

products (sample)

id	name	category	price

employees (sample)

id	name	title	hire_date	salary	department

Popup

Labels